﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_MailAddExtAttFile]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_MailAddExtAttFile];
GO
CREATE PROCEDURE [dbo].[sproc_MailAddExtAttFile]
    (
     @MailID            [int],
     @FileName         [nvarchar](300),
     @FileSize         [numeric],
    @FileAttribute         [int],
    @FileVisualPath             [nvarchar](100)
)
AS 
  
INSERT INTO TabMailAttachFiles
     ( 
     [MailID],
     [FileName],
     [FileSize],
     [FileAttribute],
     [FileVisualPath]
     ) 
 
VALUES 
    ( 
     @MailID,
     @FileName,
     @FileSize,
     @FileAttribute,
     @FileVisualPath
     )